{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>TO_CHAR(E.COMPLETE_TIME,'YYYYM</th>\n",
       "      <th>ACCEPT_AREA_NAME</th>\n",
       "      <th>ACCEPT_CITY_NAME</th>\n",
       "      <th>CREDIT_BY</th>\n",
       "      <th>C_NUM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201801</td>\n",
       "      <td>云南省</td>\n",
       "      <td>昭通市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>201801</td>\n",
       "      <td>云南省</td>\n",
       "      <td>昭通市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>乌兰察布市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>乌兰察布市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>乌海市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>乌海市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>兴安盟</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>兴安盟</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>包头市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>包头市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>呼伦贝尔市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>呼和浩特市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>呼和浩特市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>巴彦淖尔市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>巴彦淖尔市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>赤峰市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>赤峰市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>通辽市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>通辽市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>鄂尔多斯市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>鄂尔多斯市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>锡林郭勒盟</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>锡林郭勒盟</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>阿拉善盟</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>内江市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>内江市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>凉山彝族自治州</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>凉山彝族自治州</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8558</th>\n",
       "      <td>201906</td>\n",
       "      <td>广西壮族自治区</td>\n",
       "      <td>柳州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8559</th>\n",
       "      <td>201906</td>\n",
       "      <td>新疆维吾尔自治区</td>\n",
       "      <td>乌鲁木齐市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8560</th>\n",
       "      <td>201906</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>无锡市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8561</th>\n",
       "      <td>201906</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>淮安市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8562</th>\n",
       "      <td>201906</td>\n",
       "      <td>江西省</td>\n",
       "      <td>赣州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8563</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>保定市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8564</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>唐山市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8565</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>廊坊市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8566</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>张家口市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8567</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>承德市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8568</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>沧州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8569</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>石家庄市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8570</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>秦皇岛市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8571</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>衡水市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8572</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>邢台市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8573</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>邯郸市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8574</th>\n",
       "      <td>201906</td>\n",
       "      <td>河南省</td>\n",
       "      <td>洛阳市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8575</th>\n",
       "      <td>201906</td>\n",
       "      <td>河南省</td>\n",
       "      <td>焦作市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8576</th>\n",
       "      <td>201906</td>\n",
       "      <td>浙江省</td>\n",
       "      <td>台州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8577</th>\n",
       "      <td>201906</td>\n",
       "      <td>浙江省</td>\n",
       "      <td>杭州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8578</th>\n",
       "      <td>201906</td>\n",
       "      <td>浙江省</td>\n",
       "      <td>湖州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8579</th>\n",
       "      <td>201906</td>\n",
       "      <td>湖北省</td>\n",
       "      <td>咸宁市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8580</th>\n",
       "      <td>201906</td>\n",
       "      <td>湖北省</td>\n",
       "      <td>孝感市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8581</th>\n",
       "      <td>201906</td>\n",
       "      <td>湖北省</td>\n",
       "      <td>荆门市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8582</th>\n",
       "      <td>201906</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>嘉峪关市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8583</th>\n",
       "      <td>201906</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>白银市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8584</th>\n",
       "      <td>201906</td>\n",
       "      <td>西藏自治区</td>\n",
       "      <td>山南地区</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8585</th>\n",
       "      <td>201906</td>\n",
       "      <td>西藏自治区</td>\n",
       "      <td>昌都地区</td>\n",
       "      <td>GUOFU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8586</th>\n",
       "      <td>201906</td>\n",
       "      <td>西藏自治区</td>\n",
       "      <td>林芝地区</td>\n",
       "      <td>GUOFU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8587</th>\n",
       "      <td>201906</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>重庆市辖区</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>822</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8588 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      TO_CHAR(E.COMPLETE_TIME,'YYYYM ACCEPT_AREA_NAME ACCEPT_CITY_NAME  \\\n",
       "0                             201801              云南省              昭通市   \n",
       "1                             201801              云南省              昭通市   \n",
       "2                             201801           内蒙古自治区            乌兰察布市   \n",
       "3                             201801           内蒙古自治区            乌兰察布市   \n",
       "4                             201801           内蒙古自治区              乌海市   \n",
       "5                             201801           内蒙古自治区              乌海市   \n",
       "6                             201801           内蒙古自治区              兴安盟   \n",
       "7                             201801           内蒙古自治区              兴安盟   \n",
       "8                             201801           内蒙古自治区              包头市   \n",
       "9                             201801           内蒙古自治区              包头市   \n",
       "10                            201801           内蒙古自治区            呼伦贝尔市   \n",
       "11                            201801           内蒙古自治区            呼和浩特市   \n",
       "12                            201801           内蒙古自治区            呼和浩特市   \n",
       "13                            201801           内蒙古自治区            巴彦淖尔市   \n",
       "14                            201801           内蒙古自治区            巴彦淖尔市   \n",
       "15                            201801           内蒙古自治区              赤峰市   \n",
       "16                            201801           内蒙古自治区              赤峰市   \n",
       "17                            201801           内蒙古自治区              通辽市   \n",
       "18                            201801           内蒙古自治区              通辽市   \n",
       "19                            201801           内蒙古自治区            鄂尔多斯市   \n",
       "20                            201801           内蒙古自治区            鄂尔多斯市   \n",
       "21                            201801           内蒙古自治区            锡林郭勒盟   \n",
       "22                            201801           内蒙古自治区            锡林郭勒盟   \n",
       "23                            201801           内蒙古自治区             阿拉善盟   \n",
       "24                            201801              四川省              乐山市   \n",
       "25                            201801              四川省              乐山市   \n",
       "26                            201801              四川省              内江市   \n",
       "27                            201801              四川省              内江市   \n",
       "28                            201801              四川省          凉山彝族自治州   \n",
       "29                            201801              四川省          凉山彝族自治州   \n",
       "...                              ...              ...              ...   \n",
       "8558                          201906          广西壮族自治区              柳州市   \n",
       "8559                          201906         新疆维吾尔自治区            乌鲁木齐市   \n",
       "8560                          201906              江苏省              无锡市   \n",
       "8561                          201906              江苏省              淮安市   \n",
       "8562                          201906              江西省              赣州市   \n",
       "8563                          201906              河北省              保定市   \n",
       "8564                          201906              河北省              唐山市   \n",
       "8565                          201906              河北省              廊坊市   \n",
       "8566                          201906              河北省             张家口市   \n",
       "8567                          201906              河北省              承德市   \n",
       "8568                          201906              河北省              沧州市   \n",
       "8569                          201906              河北省             石家庄市   \n",
       "8570                          201906              河北省             秦皇岛市   \n",
       "8571                          201906              河北省              衡水市   \n",
       "8572                          201906              河北省              邢台市   \n",
       "8573                          201906              河北省              邯郸市   \n",
       "8574                          201906              河南省              洛阳市   \n",
       "8575                          201906              河南省              焦作市   \n",
       "8576                          201906              浙江省              台州市   \n",
       "8577                          201906              浙江省              杭州市   \n",
       "8578                          201906              浙江省              湖州市   \n",
       "8579                          201906              湖北省              咸宁市   \n",
       "8580                          201906              湖北省              孝感市   \n",
       "8581                          201906              湖北省              荆门市   \n",
       "8582                          201906              甘肃省             嘉峪关市   \n",
       "8583                          201906              甘肃省              白银市   \n",
       "8584                          201906            西藏自治区             山南地区   \n",
       "8585                          201906            西藏自治区             昌都地区   \n",
       "8586                          201906            西藏自治区             林芝地区   \n",
       "8587                          201906              重庆市            重庆市辖区   \n",
       "\n",
       "         CREDIT_BY  C_NUM  \n",
       "0          ZHONGAN    188  \n",
       "1           ZIYING     24  \n",
       "2          ZHONGAN     87  \n",
       "3           ZIYING     11  \n",
       "4          ZHONGAN     19  \n",
       "5           ZIYING      4  \n",
       "6          ZHONGAN     89  \n",
       "7           ZIYING     29  \n",
       "8          ZHONGAN    172  \n",
       "9           ZIYING     40  \n",
       "10         ZHONGAN      9  \n",
       "11         ZHONGAN     50  \n",
       "12          ZIYING      4  \n",
       "13         ZHONGAN     76  \n",
       "14          ZIYING     18  \n",
       "15         ZHONGAN    204  \n",
       "16          ZIYING     46  \n",
       "17         ZHONGAN    102  \n",
       "18          ZIYING     15  \n",
       "19         ZHONGAN     96  \n",
       "20          ZIYING     23  \n",
       "21         ZHONGAN    309  \n",
       "22          ZIYING     56  \n",
       "23         ZHONGAN      1  \n",
       "24         ZHONGAN   2126  \n",
       "25          ZIYING    138  \n",
       "26         ZHONGAN    120  \n",
       "27          ZIYING      7  \n",
       "28         ZHONGAN    163  \n",
       "29          ZIYING     14  \n",
       "...            ...    ...  \n",
       "8558       ZHONGAN      7  \n",
       "8559       ZHONGAN      6  \n",
       "8560  ZIZHUSHOUXIN    622  \n",
       "8561  ZIZHUSHOUXIN    800  \n",
       "8562       ZHONGAN      1  \n",
       "8563       ZHONGAN      1  \n",
       "8564       ZHONGAN      3  \n",
       "8565       ZHONGAN      2  \n",
       "8566       ZHONGAN      3  \n",
       "8567       ZHONGAN      1  \n",
       "8568       ZHONGAN      1  \n",
       "8569       ZHONGAN     15  \n",
       "8570       ZHONGAN      2  \n",
       "8571       ZHONGAN      2  \n",
       "8572       ZHONGAN      1  \n",
       "8573       ZHONGAN      4  \n",
       "8574       ZHONGAN      1  \n",
       "8575       ZHONGAN      1  \n",
       "8576       ZHONGAN      1  \n",
       "8577       ZHONGAN      3  \n",
       "8578       ZHONGAN      3  \n",
       "8579       ZHONGAN      4  \n",
       "8580       ZHONGAN      2  \n",
       "8581       ZHONGAN      1  \n",
       "8582       ZHONGAN      1  \n",
       "8583       ZHONGAN      1  \n",
       "8584        ZIYING      1  \n",
       "8585         GUOFU      1  \n",
       "8586         GUOFU      1  \n",
       "8587  ZIZHUSHOUXIN    822  \n",
       "\n",
       "[8588 rows x 5 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv('1.csv')\n",
    "df1 = pd.read_csv('2.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>TO_CHAR(E.COMPLETE_TIME,'YYYYM</th>\n",
       "      <th>ACCEPT_AREA_NAME</th>\n",
       "      <th>ACCEPT_CITY_NAME</th>\n",
       "      <th>CREDIT_BY</th>\n",
       "      <th>OVERDUE_NUM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>201801</td>\n",
       "      <td>云南省</td>\n",
       "      <td>昭通市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>乌兰察布市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>兴安盟</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>包头市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>包头市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>呼和浩特市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>巴彦淖尔市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>赤峰市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>赤峰市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>通辽市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>鄂尔多斯市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>锡林郭勒盟</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>201801</td>\n",
       "      <td>内蒙古自治区</td>\n",
       "      <td>锡林郭勒盟</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>内江市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>凉山彝族自治州</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>南充市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>南充市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>巴中市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>巴中市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>广元市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>成都市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>成都市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>201801</td>\n",
       "      <td>四川省</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4100</th>\n",
       "      <td>201906</td>\n",
       "      <td>广西壮族自治区</td>\n",
       "      <td>柳州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4101</th>\n",
       "      <td>201906</td>\n",
       "      <td>新疆维吾尔自治区</td>\n",
       "      <td>乌鲁木齐市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4102</th>\n",
       "      <td>201906</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>无锡市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4103</th>\n",
       "      <td>201906</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>淮安市</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4104</th>\n",
       "      <td>201906</td>\n",
       "      <td>江西省</td>\n",
       "      <td>赣州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4105</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>保定市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4106</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>唐山市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4107</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>廊坊市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4108</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>张家口市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4109</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>承德市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4110</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>沧州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4111</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>石家庄市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4112</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>秦皇岛市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4113</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>衡水市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4114</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>邢台市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4115</th>\n",
       "      <td>201906</td>\n",
       "      <td>河北省</td>\n",
       "      <td>邯郸市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4116</th>\n",
       "      <td>201906</td>\n",
       "      <td>河南省</td>\n",
       "      <td>洛阳市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4117</th>\n",
       "      <td>201906</td>\n",
       "      <td>河南省</td>\n",
       "      <td>焦作市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4118</th>\n",
       "      <td>201906</td>\n",
       "      <td>浙江省</td>\n",
       "      <td>台州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4119</th>\n",
       "      <td>201906</td>\n",
       "      <td>浙江省</td>\n",
       "      <td>杭州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4120</th>\n",
       "      <td>201906</td>\n",
       "      <td>浙江省</td>\n",
       "      <td>湖州市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4121</th>\n",
       "      <td>201906</td>\n",
       "      <td>湖北省</td>\n",
       "      <td>咸宁市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4122</th>\n",
       "      <td>201906</td>\n",
       "      <td>湖北省</td>\n",
       "      <td>孝感市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4123</th>\n",
       "      <td>201906</td>\n",
       "      <td>湖北省</td>\n",
       "      <td>荆门市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4124</th>\n",
       "      <td>201906</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>嘉峪关市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4125</th>\n",
       "      <td>201906</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>白银市</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4126</th>\n",
       "      <td>201906</td>\n",
       "      <td>西藏自治区</td>\n",
       "      <td>山南地区</td>\n",
       "      <td>ZIYING</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4127</th>\n",
       "      <td>201906</td>\n",
       "      <td>西藏自治区</td>\n",
       "      <td>昌都地区</td>\n",
       "      <td>GUOFU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4128</th>\n",
       "      <td>201906</td>\n",
       "      <td>西藏自治区</td>\n",
       "      <td>林芝地区</td>\n",
       "      <td>GUOFU</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4129</th>\n",
       "      <td>201906</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>重庆市辖区</td>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>819</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4130 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      TO_CHAR(E.COMPLETE_TIME,'YYYYM ACCEPT_AREA_NAME ACCEPT_CITY_NAME  \\\n",
       "0                             201801              云南省              昭通市   \n",
       "1                             201801           内蒙古自治区            乌兰察布市   \n",
       "2                             201801           内蒙古自治区              兴安盟   \n",
       "3                             201801           内蒙古自治区              包头市   \n",
       "4                             201801           内蒙古自治区              包头市   \n",
       "5                             201801           内蒙古自治区            呼和浩特市   \n",
       "6                             201801           内蒙古自治区            巴彦淖尔市   \n",
       "7                             201801           内蒙古自治区              赤峰市   \n",
       "8                             201801           内蒙古自治区              赤峰市   \n",
       "9                             201801           内蒙古自治区              通辽市   \n",
       "10                            201801           内蒙古自治区            鄂尔多斯市   \n",
       "11                            201801           内蒙古自治区            锡林郭勒盟   \n",
       "12                            201801           内蒙古自治区            锡林郭勒盟   \n",
       "13                            201801              四川省              乐山市   \n",
       "14                            201801              四川省              乐山市   \n",
       "15                            201801              四川省              内江市   \n",
       "16                            201801              四川省          凉山彝族自治州   \n",
       "17                            201801              四川省              南充市   \n",
       "18                            201801              四川省              南充市   \n",
       "19                            201801              四川省              宜宾市   \n",
       "20                            201801              四川省              宜宾市   \n",
       "21                            201801              四川省              巴中市   \n",
       "22                            201801              四川省              巴中市   \n",
       "23                            201801              四川省              广元市   \n",
       "24                            201801              四川省              德阳市   \n",
       "25                            201801              四川省              成都市   \n",
       "26                            201801              四川省              成都市   \n",
       "27                            201801              四川省             攀枝花市   \n",
       "28                            201801              四川省              泸州市   \n",
       "29                            201801              四川省              泸州市   \n",
       "...                              ...              ...              ...   \n",
       "4100                          201906          广西壮族自治区              柳州市   \n",
       "4101                          201906         新疆维吾尔自治区            乌鲁木齐市   \n",
       "4102                          201906              江苏省              无锡市   \n",
       "4103                          201906              江苏省              淮安市   \n",
       "4104                          201906              江西省              赣州市   \n",
       "4105                          201906              河北省              保定市   \n",
       "4106                          201906              河北省              唐山市   \n",
       "4107                          201906              河北省              廊坊市   \n",
       "4108                          201906              河北省             张家口市   \n",
       "4109                          201906              河北省              承德市   \n",
       "4110                          201906              河北省              沧州市   \n",
       "4111                          201906              河北省             石家庄市   \n",
       "4112                          201906              河北省             秦皇岛市   \n",
       "4113                          201906              河北省              衡水市   \n",
       "4114                          201906              河北省              邢台市   \n",
       "4115                          201906              河北省              邯郸市   \n",
       "4116                          201906              河南省              洛阳市   \n",
       "4117                          201906              河南省              焦作市   \n",
       "4118                          201906              浙江省              台州市   \n",
       "4119                          201906              浙江省              杭州市   \n",
       "4120                          201906              浙江省              湖州市   \n",
       "4121                          201906              湖北省              咸宁市   \n",
       "4122                          201906              湖北省              孝感市   \n",
       "4123                          201906              湖北省              荆门市   \n",
       "4124                          201906              甘肃省             嘉峪关市   \n",
       "4125                          201906              甘肃省              白银市   \n",
       "4126                          201906            西藏自治区             山南地区   \n",
       "4127                          201906            西藏自治区             昌都地区   \n",
       "4128                          201906            西藏自治区             林芝地区   \n",
       "4129                          201906              重庆市            重庆市辖区   \n",
       "\n",
       "         CREDIT_BY  OVERDUE_NUM  \n",
       "0          ZHONGAN            9  \n",
       "1           ZIYING            1  \n",
       "2           ZIYING            1  \n",
       "3          ZHONGAN            1  \n",
       "4           ZIYING            1  \n",
       "5          ZHONGAN            3  \n",
       "6           ZIYING            1  \n",
       "7          ZHONGAN            4  \n",
       "8           ZIYING            4  \n",
       "9          ZHONGAN            2  \n",
       "10         ZHONGAN            2  \n",
       "11         ZHONGAN            6  \n",
       "12          ZIYING            1  \n",
       "13         ZHONGAN           83  \n",
       "14          ZIYING            7  \n",
       "15         ZHONGAN            4  \n",
       "16         ZHONGAN            9  \n",
       "17         ZHONGAN           44  \n",
       "18          ZIYING            1  \n",
       "19         ZHONGAN           54  \n",
       "20          ZIYING            2  \n",
       "21         ZHONGAN           34  \n",
       "22          ZIYING            6  \n",
       "23         ZHONGAN           13  \n",
       "24         ZHONGAN            2  \n",
       "25         ZHONGAN          170  \n",
       "26          ZIYING           19  \n",
       "27         ZHONGAN           15  \n",
       "28         ZHONGAN           11  \n",
       "29          ZIYING            1  \n",
       "...            ...          ...  \n",
       "4100       ZHONGAN            7  \n",
       "4101       ZHONGAN            6  \n",
       "4102  ZIZHUSHOUXIN          620  \n",
       "4103  ZIZHUSHOUXIN          797  \n",
       "4104       ZHONGAN            1  \n",
       "4105       ZHONGAN            1  \n",
       "4106       ZHONGAN            3  \n",
       "4107       ZHONGAN            2  \n",
       "4108       ZHONGAN            3  \n",
       "4109       ZHONGAN            1  \n",
       "4110       ZHONGAN            1  \n",
       "4111       ZHONGAN           15  \n",
       "4112       ZHONGAN            2  \n",
       "4113       ZHONGAN            2  \n",
       "4114       ZHONGAN            1  \n",
       "4115       ZHONGAN            3  \n",
       "4116       ZHONGAN            1  \n",
       "4117       ZHONGAN            1  \n",
       "4118       ZHONGAN            1  \n",
       "4119       ZHONGAN            3  \n",
       "4120       ZHONGAN            3  \n",
       "4121       ZHONGAN            4  \n",
       "4122       ZHONGAN            2  \n",
       "4123       ZHONGAN            1  \n",
       "4124       ZHONGAN            1  \n",
       "4125       ZHONGAN            1  \n",
       "4126        ZIYING            1  \n",
       "4127         GUOFU            1  \n",
       "4128         GUOFU            1  \n",
       "4129  ZIZHUSHOUXIN          819  \n",
       "\n",
       "[4130 rows x 5 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = pd.merge(df, df1, on=[\"TO_CHAR(E.COMPLETE_TIME,'YYYYM\",'ACCEPT_AREA_NAME','ACCEPT_CITY_NAME','CREDIT_BY'], how='left',sort=False,copy=False)\n",
    "df2.to_csv('3.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
